USE [BDIntegration]
GO
/****** Object:  StoredProcedure [dbo].[sp_User_Validate]    Script Date: 22/08/2013 12:17:04 a.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_User_InicioSesion]
      @cPerUsuCodigo nvarchar(15)
AS

BEGIN

       SET NOCOUNT ON;
SELECT pu.cpercodigo
FROM   perusuario pu with (nolock)
		inner join persona p on pu.cPerCodigo = p.cPerCodigo
WHERE  cperusucodigo = @cPerUsuCodigo
END